﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.Master" AutoEventWireup="true" CodeBehind="StatisticalOfDepartNum.aspx.cs" Inherits="MyHospital.web.StatisticalOfDepartNum" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
    <style>
        .total {
            margin-right: 170px;
        }
        .total p {
            font-size:14px;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder2" runat="server">
    <div class="total">
    <p>各科室医生数量分布图</p>
    <asp:Chart ID="Chart1" runat="server" DataSourceID="SqlDataSource1" Height="440px" Width="901px">
        <Series>
            <asp:Series Name="Series1" XValueMember="departName" YValueMembers="Expr1"></asp:Series>
        </Series>
        <ChartAreas>
            <asp:ChartArea Name="ChartArea1"></asp:ChartArea>
        </ChartAreas>
    </asp:Chart>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyHospitalConnectionString2 %>" SelectCommand="SELECT COUNT(*) AS Expr1, Department.departName FROM Department INNER JOIN Doctor ON Department.departId = Doctor.departId GROUP BY Department.departName"></asp:SqlDataSource>
  </div>
</asp:Content>